Overview
Brought to you by YData
Dataset statistics
| Number of variables | 10 |
|---|---|
| Number of observations | 32434489 |
| Missing cells | 2078068 |
| Missing cells (%) | 0.6% |
| Duplicate rows | 0 |
| Duplicate rows (%) | 0.0% |
| Total size in memory | 2.4 GiB |
| Average record size in memory | 80.0 B |
Variable types
| Numeric | 8 |
|---|---|
| Categorical | 2 |
eval_set has constant value "prior" | Constant |
days_since_prior_order has 2078068 (6.4%) missing values | Missing |
order_dow has 6209666 (19.1%) zeros | Zeros |
days_since_prior_order has 448698 (1.4%) zeros | Zeros |
Reproduction
| Analysis started | 2024-11-01 20:57:22.573259 |
|---|---|
| Analysis finished | 2024-11-01 21:07:29.668437 |
| Duration | 10 minutes and 7.1 seconds |
| Software version | ydata-profiling v0.0.dev0 |
| Download configuration | config.json |
Variables
order_id
Real number (ℝ)
| Distinct | 3214874 |
|---|---|
| Distinct (%) | 9.9% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 1710748.5 |
| Minimum | 2 |
|---|---|
| Maximum | 3421083 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 247.5 MiB |
Quantile statistics
| Minimum | 2 |
|---|---|
| 5-th percentile | 170925 |
| Q1 | 855943 |
| median | 1711048 |
| Q3 | 2565514 |
| 95-th percentile | 3250209 |
| Maximum | 3421083 |
| Range | 3421081 |
| Interquartile range (IQR) | 1709571 |
Descriptive statistics
| Standard deviation | 987300.7 |
|---|---|
| Coefficient of variation (CV) | 0.57711621 |
| Kurtosis | -1.1991283 |
| Mean | 1710748.5 |
| Median Absolute Deviation (MAD) | 854783 |
| Skewness | -0.00048974146 |
| Sum | 5.5487254 × 1013 |
| Variance | 9.7476267 × 1011 |
| Monotonicity | Increasing |
Histogram with fixed size bins (bins=50)
| Value | Count | Frequency (%) |
| 1564244 | 145 | < 0.1% |
| 790903 | 137 | < 0.1% |
| 61355 | 127 | < 0.1% |
| 2970392 | 121 | < 0.1% |
| 2069920 | 116 | < 0.1% |
| 3308010 | 115 | < 0.1% |
| 2753324 | 114 | < 0.1% |
| 2499774 | 112 | < 0.1% |
| 2621625 | 109 | < 0.1% |
| 77151 | 109 | < 0.1% |
| Other values (3214864) | 32433284 |
| Value | Count | Frequency (%) |
| 2 | 9 | < 0.1% |
| 3 | 8 | < 0.1% |
| 4 | 13 | |
| 5 | 26 | |
| 6 | 3 | < 0.1% |
| 7 | 2 | < 0.1% |
| 8 | 1 | < 0.1% |
| 9 | 15 | |
| 10 | 15 | |
| 11 | 5 | < 0.1% |
| Value | Count | Frequency (%) |
| 3421083 | 10 | |
| 3421082 | 7 | |
| 3421081 | 7 | |
| 3421080 | 9 | |
| 3421079 | 1 | < 0.1% |
| 3421078 | 9 | |
| 3421077 | 4 | < 0.1% |
| 3421076 | 8 | |
| 3421075 | 8 | |
| 3421074 | 4 | < 0.1% |
product_id
Real number (ℝ)
| Distinct | 49677 |
|---|---|
| Distinct (%) | 0.2% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 25576.338 |
| Minimum | 1 |
|---|---|
| Maximum | 49688 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 247.5 MiB |
Quantile statistics
| Minimum | 1 |
|---|---|
| 5-th percentile | 3376 |
| Q1 | 13530 |
| median | 25256 |
| Q3 | 37935 |
| 95-th percentile | 47559 |
| Maximum | 49688 |
| Range | 49687 |
| Interquartile range (IQR) | 24405 |
Descriptive statistics
| Standard deviation | 14096.689 |
|---|---|
| Coefficient of variation (CV) | 0.55116136 |
| Kurtosis | -1.1408165 |
| Mean | 25576.338 |
| Median Absolute Deviation (MAD) | 12080 |
| Skewness | -0.021130583 |
| Sum | 8.2955544 × 1011 |
| Variance | 1.9871664 × 108 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=50)
| Value | Count | Frequency (%) |
| 24852 | 472565 | 1.5% |
| 13176 | 379450 | 1.2% |
| 21137 | 264683 | 0.8% |
| 21903 | 241921 | 0.7% |
| 47209 | 213584 | 0.7% |
| 47766 | 176815 | 0.5% |
| 47626 | 152657 | 0.5% |
| 16797 | 142951 | 0.4% |
| 26209 | 140627 | 0.4% |
| 27845 | 137905 | 0.4% |
| Other values (49667) | 30111331 |
| Value | Count | Frequency (%) |
| 1 | 1852 | |
| 2 | 90 | < 0.1% |
| 3 | 277 | < 0.1% |
| 4 | 329 | < 0.1% |
| 5 | 15 | < 0.1% |
| 6 | 8 | < 0.1% |
| 7 | 30 | < 0.1% |
| 8 | 165 | < 0.1% |
| 9 | 156 | < 0.1% |
| 10 | 2572 |
| Value | Count | Frequency (%) |
| 49688 | 89 | < 0.1% |
| 49687 | 13 | < 0.1% |
| 49686 | 120 | < 0.1% |
| 49685 | 49 | < 0.1% |
| 49684 | 9 | < 0.1% |
| 49683 | 97315 | |
| 49682 | 108 | < 0.1% |
| 49681 | 70 | < 0.1% |
| 49680 | 1018 | < 0.1% |
| 49679 | 132 | < 0.1% |
add_to_cart_order
Real number (ℝ)
| Distinct | 145 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 8.3510755 |
| Minimum | 1 |
|---|---|
| Maximum | 145 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 247.5 MiB |
Quantile statistics
| Minimum | 1 |
|---|---|
| 5-th percentile | 1 |
| Q1 | 3 |
| median | 6 |
| Q3 | 11 |
| 95-th percentile | 22 |
| Maximum | 145 |
| Range | 144 |
| Interquartile range (IQR) | 8 |
Descriptive statistics
| Standard deviation | 7.1266712 |
|---|---|
| Coefficient of variation (CV) | 0.85338363 |
| Kurtosis | 5.643873 |
| Mean | 8.3510755 |
| Median Absolute Deviation (MAD) | 4 |
| Skewness | 1.8180712 |
| Sum | 2.7086287 × 108 |
| Variance | 50.789442 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=50)
| Value | Count | Frequency (%) |
| 1 | 3214874 | 9.9% |
| 2 | 3058126 | 9.4% |
| 3 | 2871133 | 8.9% |
| 4 | 2664106 | 8.2% |
| 5 | 2442025 | 7.5% |
| 6 | 2213695 | 6.8% |
| 7 | 1986020 | 6.1% |
| 8 | 1766014 | 5.4% |
| 9 | 1562640 | 4.8% |
| 10 | 1378293 | 4.2% |
| Other values (135) | 9277563 |
| Value | Count | Frequency (%) |
| 1 | 3214874 | |
| 2 | 3058126 | |
| 3 | 2871133 | |
| 4 | 2664106 | |
| 5 | 2442025 | |
| 6 | 2213695 | |
| 7 | 1986020 | |
| 8 | 1766014 | |
| 9 | 1562640 | |
| 10 | 1378293 |
| Value | Count | Frequency (%) |
| 145 | 1 | |
| 144 | 1 | |
| 143 | 1 | |
| 142 | 1 | |
| 141 | 1 | |
| 140 | 1 | |
| 139 | 1 | |
| 138 | 1 | |
| 137 | 2 | |
| 136 | 2 |
Length
| Max length | 1 |
|---|---|
| Median length | 1 |
| Mean length | 1 |
| Min length | 1 |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | 1 |
|---|---|
| 2nd row | 1 |
| 3rd row | 0 |
| 4th row | 1 |
| 5th row | 0 |
Common Values
| Value | Count | Frequency (%) |
| 1 | 19126536 | |
| 0 | 13307953 |
Length
Histogram of lengths of the category
Common Values (Plot)
| Value | Count | Frequency (%) |
| 1 | 19126536 | |
| 0 | 13307953 |
Most occurring characters
| Value | Count | Frequency (%) |
| 1 | 19126536 | |
| 0 | 13307953 |
Most occurring categories
| Value | Count | Frequency (%) |
| (unknown) | 32434489 |
Most frequent character per category
(unknown)
| Value | Count | Frequency (%) |
| 1 | 19126536 | |
| 0 | 13307953 |
Most occurring scripts
| Value | Count | Frequency (%) |
| (unknown) | 32434489 |
Most frequent character per script
(unknown)
| Value | Count | Frequency (%) |
| 1 | 19126536 | |
| 0 | 13307953 |
Most occurring blocks
| Value | Count | Frequency (%) |
| (unknown) | 32434489 |
Most frequent character per block
(unknown)
| Value | Count | Frequency (%) |
| 1 | 19126536 | |
| 0 | 13307953 |
user_id
Real number (ℝ)
| Distinct | 206209 |
|---|---|
| Distinct (%) | 0.6% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 102937.24 |
| Minimum | 1 |
|---|---|
| Maximum | 206209 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 247.5 MiB |
Quantile statistics
| Minimum | 1 |
|---|---|
| 5-th percentile | 10469 |
| Q1 | 51421 |
| median | 102611 |
| Q3 | 154391 |
| 95-th percentile | 195736 |
| Maximum | 206209 |
| Range | 206208 |
| Interquartile range (IQR) | 102970 |
Descriptive statistics
| Standard deviation | 59466.478 |
|---|---|
| Coefficient of variation (CV) | 0.57769645 |
| Kurtosis | -1.2009235 |
| Mean | 102937.24 |
| Median Absolute Deviation (MAD) | 51493 |
| Skewness | 0.0066119537 |
| Sum | 3.3387168 × 1012 |
| Variance | 3.536262 × 109 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=50)
| Value | Count | Frequency (%) |
| 201268 | 3725 | < 0.1% |
| 129928 | 3638 | < 0.1% |
| 164055 | 3061 | < 0.1% |
| 186704 | 2936 | < 0.1% |
| 176478 | 2921 | < 0.1% |
| 182401 | 2907 | < 0.1% |
| 137629 | 2901 | < 0.1% |
| 33731 | 2888 | < 0.1% |
| 108187 | 2760 | < 0.1% |
| 4694 | 2735 | < 0.1% |
| Other values (206199) | 32404017 |
| Value | Count | Frequency (%) |
| 1 | 59 | < 0.1% |
| 2 | 195 | |
| 3 | 88 | |
| 4 | 18 | < 0.1% |
| 5 | 37 | < 0.1% |
| 6 | 14 | < 0.1% |
| 7 | 206 | |
| 8 | 49 | < 0.1% |
| 9 | 76 | < 0.1% |
| 10 | 143 |
| Value | Count | Frequency (%) |
| 206209 | 129 | < 0.1% |
| 206208 | 677 | |
| 206207 | 223 | < 0.1% |
| 206206 | 285 | |
| 206205 | 32 | < 0.1% |
| 206204 | 54 | < 0.1% |
| 206203 | 119 | < 0.1% |
| 206202 | 198 | < 0.1% |
| 206201 | 404 | |
| 206200 | 279 |
eval_set
Categorical
Constant
| Distinct | 1 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 247.5 MiB |
| prior |
|---|
Length
| Max length | 5 |
|---|---|
| Median length | 5 |
| Mean length | 5 |
| Min length | 5 |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | prior |
|---|---|
| 2nd row | prior |
| 3rd row | prior |
| 4th row | prior |
| 5th row | prior |
Common Values
| Value | Count | Frequency (%) |
| prior | 32434489 |
Length
Histogram of lengths of the category
Common Values (Plot)
| Value | Count | Frequency (%) |
| prior | 32434489 |
Most occurring characters
| Value | Count | Frequency (%) |
| r | 64868978 | |
| p | 32434489 | |
| i | 32434489 | |
| o | 32434489 |
Most occurring categories
| Value | Count | Frequency (%) |
| (unknown) | 162172445 |
Most frequent character per category
(unknown)
| Value | Count | Frequency (%) |
| r | 64868978 | |
| p | 32434489 | |
| i | 32434489 | |
| o | 32434489 |
Most occurring scripts
| Value | Count | Frequency (%) |
| (unknown) | 162172445 |
Most frequent character per script
(unknown)
| Value | Count | Frequency (%) |
| r | 64868978 | |
| p | 32434489 | |
| i | 32434489 | |
| o | 32434489 |
Most occurring blocks
| Value | Count | Frequency (%) |
| (unknown) | 162172445 |
Most frequent character per block
(unknown)
| Value | Count | Frequency (%) |
| r | 64868978 | |
| p | 32434489 | |
| i | 32434489 | |
| o | 32434489 |
order_number
Real number (ℝ)
| Distinct | 99 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 17.14205 |
| Minimum | 1 |
|---|---|
| Maximum | 99 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 247.5 MiB |
Quantile statistics
| Minimum | 1 |
|---|---|
| 5-th percentile | 1 |
| Q1 | 5 |
| median | 11 |
| Q3 | 24 |
| 95-th percentile | 54 |
| Maximum | 99 |
| Range | 98 |
| Interquartile range (IQR) | 19 |
Descriptive statistics
| Standard deviation | 17.53504 |
|---|---|
| Coefficient of variation (CV) | 1.0229255 |
| Kurtosis | 3.256605 |
| Mean | 17.14205 |
| Median Absolute Deviation (MAD) | 8 |
| Skewness | 1.7568963 |
| Sum | 5.5599364 × 108 |
| Variance | 307.47765 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=50)
| Value | Count | Frequency (%) |
| 1 | 2078068 | 6.4% |
| 3 | 2050731 | 6.3% |
| 2 | 2048332 | 6.3% |
| 4 | 1820298 | 5.6% |
| 5 | 1628411 | 5.0% |
| 6 | 1472238 | 4.5% |
| 7 | 1333847 | 4.1% |
| 8 | 1219148 | 3.8% |
| 9 | 1120468 | 3.5% |
| 10 | 1028704 | 3.2% |
| Other values (89) | 16634244 |
| Value | Count | Frequency (%) |
| 1 | 2078068 | |
| 2 | 2048332 | |
| 3 | 2050731 | |
| 4 | 1820298 | |
| 5 | 1628411 | |
| 6 | 1472238 | |
| 7 | 1333847 | |
| 8 | 1219148 | |
| 9 | 1120468 | |
| 10 | 1028704 |
| Value | Count | Frequency (%) |
| 99 | 12436 | |
| 98 | 12858 | |
| 97 | 13367 | |
| 96 | 13746 | |
| 95 | 14528 | |
| 94 | 15212 | |
| 93 | 15407 | |
| 92 | 16229 | |
| 91 | 16862 | |
| 90 | 17209 |
order_dow
Real number (ℝ)
Zeros
| Distinct | 7 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 2.7388177 |
| Minimum | 0 |
|---|---|
| Maximum | 6 |
| Zeros | 6209666 |
| Zeros (%) | 19.1% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 247.5 MiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 0 |
| Q1 | 1 |
| median | 3 |
| Q3 | 5 |
| 95-th percentile | 6 |
| Maximum | 6 |
| Range | 6 |
| Interquartile range (IQR) | 4 |
Descriptive statistics
| Standard deviation | 2.0900491 |
|---|---|
| Coefficient of variation (CV) | 0.76312092 |
| Kurtosis | -1.3339893 |
| Mean | 2.7388177 |
| Median Absolute Deviation (MAD) | 2 |
| Skewness | 0.18019293 |
| Sum | 88832152 |
| Variance | 4.3683052 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=7)
| Value | Count | Frequency (%) |
| 0 | 6209666 | |
| 1 | 5665856 | |
| 6 | 4500304 | |
| 2 | 4217798 | |
| 5 | 4209533 | |
| 3 | 3844117 | |
| 4 | 3787215 |
| Value | Count | Frequency (%) |
| 0 | 6209666 | |
| 1 | 5665856 | |
| 2 | 4217798 | |
| 3 | 3844117 | |
| 4 | 3787215 | |
| 5 | 4209533 | |
| 6 | 4500304 |
| Value | Count | Frequency (%) |
| 6 | 4500304 | |
| 5 | 4209533 | |
| 4 | 3787215 | |
| 3 | 3844117 | |
| 2 | 4217798 | |
| 1 | 5665856 | |
| 0 | 6209666 |
order_hour_of_day
Real number (ℝ)
| Distinct | 24 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 13.424977 |
| Minimum | 0 |
|---|---|
| Maximum | 23 |
| Zeros | 218948 |
| Zeros (%) | 0.7% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 247.5 MiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 7 |
| Q1 | 10 |
| median | 13 |
| Q3 | 16 |
| 95-th percentile | 21 |
| Maximum | 23 |
| Range | 23 |
| Interquartile range (IQR) | 6 |
Descriptive statistics
| Standard deviation | 4.246365 |
|---|---|
| Coefficient of variation (CV) | 0.31630333 |
| Kurtosis | -0.011657572 |
| Mean | 13.424977 |
| Median Absolute Deviation (MAD) | 3 |
| Skewness | -0.044082776 |
| Sum | 4.3543228 × 108 |
| Variance | 18.031616 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=24)
| Value | Count | Frequency (%) |
| 10 | 2764426 | 8.5% |
| 11 | 2738582 | 8.4% |
| 14 | 2691548 | 8.3% |
| 15 | 2664533 | 8.2% |
| 13 | 2663292 | 8.2% |
| 12 | 2620847 | 8.1% |
| 16 | 2537458 | 7.8% |
| 9 | 2456713 | 7.6% |
| 17 | 2089465 | 6.4% |
| 8 | 1719973 | 5.3% |
| Other values (14) | 7487652 |
| Value | Count | Frequency (%) |
| 0 | 218948 | 0.7% |
| 1 | 115786 | 0.4% |
| 2 | 69434 | 0.2% |
| 3 | 51321 | 0.2% |
| 4 | 53283 | 0.2% |
| 5 | 88062 | 0.3% |
| 6 | 290795 | 0.9% |
| 7 | 891937 | 2.7% |
| 8 | 1719973 | |
| 9 | 2456713 |
| Value | Count | Frequency (%) |
| 23 | 402620 | 1.2% |
| 22 | 634734 | 2.0% |
| 21 | 796370 | 2.5% |
| 20 | 977038 | 3.0% |
| 19 | 1259401 | |
| 18 | 1637923 | |
| 17 | 2089465 | |
| 16 | 2537458 | |
| 15 | 2664533 | |
| 14 | 2691548 |
days_since_prior_order
Real number (ℝ)
Missing Zeros
| Distinct | 31 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 2078068 |
| Missing (%) | 6.4% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 11.104074 |
| Minimum | 0 |
|---|---|
| Maximum | 30 |
| Zeros | 448698 |
| Zeros (%) | 1.4% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 247.5 MiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 2 |
| Q1 | 5 |
| median | 8 |
| Q3 | 15 |
| 95-th percentile | 30 |
| Maximum | 30 |
| Range | 30 |
| Interquartile range (IQR) | 10 |
Descriptive statistics
| Standard deviation | 8.7789143 |
|---|---|
| Coefficient of variation (CV) | 0.79060299 |
| Kurtosis | -0.068967377 |
| Mean | 11.104074 |
| Median Absolute Deviation (MAD) | 4 |
| Skewness | 1.0539722 |
| Sum | 3.3707995 × 108 |
| Variance | 77.069337 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=31)
| Value | Count | Frequency (%) |
| 7 | 3479504 | 10.7% |
| 30 | 3070057 | 9.5% |
| 6 | 2519939 | 7.8% |
| 5 | 2126420 | 6.6% |
| 4 | 2080560 | 6.4% |
| 8 | 1933815 | 6.0% |
| 3 | 1877881 | 5.8% |
| 2 | 1464875 | 4.5% |
| 9 | 1218973 | 3.8% |
| 14 | 1030605 | 3.2% |
| Other values (21) | 9553792 | |
| (Missing) | 2078068 | 6.4% |
| Value | Count | Frequency (%) |
| 0 | 448698 | 1.4% |
| 1 | 941116 | 2.9% |
| 2 | 1464875 | |
| 3 | 1877881 | |
| 4 | 2080560 | |
| 5 | 2126420 | |
| 6 | 2519939 | |
| 7 | 3479504 | |
| 8 | 1933815 | |
| 9 | 1218973 | 3.8% |
| Value | Count | Frequency (%) |
| 30 | 3070057 | |
| 29 | 175640 | 0.5% |
| 28 | 253349 | 0.8% |
| 27 | 204251 | 0.6% |
| 26 | 177949 | 0.5% |
| 25 | 180584 | 0.6% |
| 24 | 193590 | 0.6% |
| 23 | 226030 | 0.7% |
| 22 | 309118 | 1.0% |
| 21 | 444557 | 1.4% |
Interactions
Correlations
| add_to_cart_order | days_since_prior_order | order_dow | order_hour_of_day | order_id | order_number | product_id | reordered | user_id | |
|---|---|---|---|---|---|---|---|---|---|
| add_to_cart_order | 1.000 | 0.078 | -0.015 | -0.015 | -0.000 | 0.000 | 0.009 | 0.096 | 0.000 |
| days_since_prior_order | 0.078 | 1.000 | -0.043 | -0.004 | -0.000 | -0.385 | 0.001 | 0.140 | 0.000 |
| order_dow | -0.015 | -0.043 | 1.000 | 0.012 | 0.001 | 0.015 | -0.003 | 0.018 | -0.002 |
| order_hour_of_day | -0.015 | -0.004 | 0.012 | 1.000 | 0.001 | -0.048 | 0.001 | 0.038 | 0.000 |
| order_id | -0.000 | -0.000 | 0.001 | 0.001 | 1.000 | -0.000 | -0.000 | 0.001 | -0.000 |
| order_number | 0.000 | -0.385 | 0.015 | -0.048 | -0.000 | 1.000 | -0.002 | 0.341 | -0.001 |
| product_id | 0.009 | 0.001 | -0.003 | 0.001 | -0.000 | -0.002 | 1.000 | 0.040 | 0.000 |
| reordered | 0.096 | 0.140 | 0.018 | 0.038 | 0.001 | 0.341 | 0.040 | 1.000 | 0.004 |
| user_id | 0.000 | 0.000 | -0.002 | 0.000 | -0.000 | -0.001 | 0.000 | 0.004 | 1.000 |
Missing values
A simple visualization of nullity by column.
Nullity matrix is a data-dense display which lets you quickly visually pick out patterns in data completion.
Sample
| order_id | product_id | add_to_cart_order | reordered | user_id | eval_set | order_number | order_dow | order_hour_of_day | days_since_prior_order | |
|---|---|---|---|---|---|---|---|---|---|---|
| 0 | 2 | 33120 | 1 | 1 | 202279 | prior | 3 | 5 | 9 | 8.0 |
| 1 | 2 | 28985 | 2 | 1 | 202279 | prior | 3 | 5 | 9 | 8.0 |
| 2 | 2 | 9327 | 3 | 0 | 202279 | prior | 3 | 5 | 9 | 8.0 |
| 3 | 2 | 45918 | 4 | 1 | 202279 | prior | 3 | 5 | 9 | 8.0 |
| 4 | 2 | 30035 | 5 | 0 | 202279 | prior | 3 | 5 | 9 | 8.0 |
| 5 | 2 | 17794 | 6 | 1 | 202279 | prior | 3 | 5 | 9 | 8.0 |
| 6 | 2 | 40141 | 7 | 1 | 202279 | prior | 3 | 5 | 9 | 8.0 |
| 7 | 2 | 1819 | 8 | 1 | 202279 | prior | 3 | 5 | 9 | 8.0 |
| 8 | 2 | 43668 | 9 | 0 | 202279 | prior | 3 | 5 | 9 | 8.0 |
| 9 | 3 | 33754 | 1 | 1 | 205970 | prior | 16 | 5 | 17 | 12.0 |
| order_id | product_id | add_to_cart_order | reordered | user_id | eval_set | order_number | order_dow | order_hour_of_day | days_since_prior_order | |
|---|---|---|---|---|---|---|---|---|---|---|
| 32434479 | 3421083 | 7854 | 1 | 0 | 25247 | prior | 24 | 2 | 6 | 21.0 |
| 32434480 | 3421083 | 45309 | 2 | 0 | 25247 | prior | 24 | 2 | 6 | 21.0 |
| 32434481 | 3421083 | 21162 | 3 | 0 | 25247 | prior | 24 | 2 | 6 | 21.0 |
| 32434482 | 3421083 | 18176 | 4 | 1 | 25247 | prior | 24 | 2 | 6 | 21.0 |
| 32434483 | 3421083 | 35211 | 5 | 0 | 25247 | prior | 24 | 2 | 6 | 21.0 |
| 32434484 | 3421083 | 39678 | 6 | 1 | 25247 | prior | 24 | 2 | 6 | 21.0 |
| 32434485 | 3421083 | 11352 | 7 | 0 | 25247 | prior | 24 | 2 | 6 | 21.0 |
| 32434486 | 3421083 | 4600 | 8 | 0 | 25247 | prior | 24 | 2 | 6 | 21.0 |
| 32434487 | 3421083 | 24852 | 9 | 1 | 25247 | prior | 24 | 2 | 6 | 21.0 |
| 32434488 | 3421083 | 5020 | 10 | 1 | 25247 | prior | 24 | 2 | 6 | 21.0 |